package com.hawthorn.redis.repository.provider;

import org.apache.ibatis.builder.annotation.ProviderMethodResolver;

/**
 * <p>todo 业务参数缓存sql类</p>
 * @author: andyten@tom.com | xukaixing@hotmail.com
 * @created: 2021/11/11 8:39 PM
 * @version v1.0.1
 * @copyright: Copyright (c)  andyten
 */
public class BizConfCacheSqlProvider implements ProviderMethodResolver
{
  public static String selectBizConf()
  {
    StringBuffer sql = new StringBuffer();
    sql.append(" select\n ");
    sql.append(" 	id,\n ");
    sql.append(" 	type,\n ");
    sql.append(" 	type_name ,\n ");
    sql.append(" 	para_key ,\n ");
    sql.append(" 	para_name ,\n ");
    sql.append(" 	type_name ,\n ");
    sql.append(" 	biz_type ,\n ");
    sql.append(" 	para_val1 ,\n ");
    sql.append(" 	para_val2 ,\n ");
    sql.append(" 	para_val3 ,\n ");
    sql.append(" 	para_val4 ,\n ");
    sql.append(" 	para_val5 ,\n ");
    sql.append(" 	status, \n ");
    sql.append(" 	biz_type bizType \n ");
    sql.append(" from\n ");
    sql.append(" 	sys_biz_conf\n ");
    return sql.toString();
  }
}
